SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vw_Control
AS
SELECT     TOP 100 PERCENT s.Agente, a1.Documento, a1.Nombres, sr.Descripcion  AS SR, l.Descripcion AS Licencia, o.Nombre  AS Organización, aa.Descripcion  AS Asignatura, p.Horas, ss.FechaBaja, ss.Nivel, p.CUPOF, p.CUISE, p.Asignatura AS ASIGNAT, 
                      p.Paquete, a1.LegajoDeMedia
FROM         dbo.tb_ServiciosAgentes s INNER JOIN
                      dbo.tb_SubserviciosAgentes ss ON s.idServicioAgente = ss.ServicioAgente LEFT OUTER JOIN
                      dbo.tb_Licencias l ON l.idLicencia = ss.Licencia INNER JOIN
                      dbo.tb_Agentes a1 ON a1.idAgente = s.Agente INNER JOIN
                      dbo.tb_Plazas p ON p.idPlaza = ss.Plaza INNER JOIN
                      dbo.tb_SituacionRevista sr ON sr.idSituacionRevista = s.SituacionRevista INNER JOIN
                      dbo.tb_Asignaturas aa ON aa.idAsignatura = p.Asignatura INNER JOIN
                      dbo.tb_Organizaciones o ON p.CUISE = o.CUISE
WHERE     (s.idServicioAgente NOT IN
                          (SELECT     idServicio
                            FROM          tb_RelInterServicios)) AND (ss.FechaBaja IS NULL) AND (sr.Descripcion = 'Titular')
ORDER BY a1.Nombres

GO
GRANT SELECT ON  [dbo].[vw_Control] TO [Juntas]
GRANT SELECT ON  [dbo].[vw_Control] TO [SoloVer]
GO
EXEC sp_addextendedproperty N'MS_DiagramPane1', N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1[50] 2[25] 3) )"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1 [56] 4 [18] 2))"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = -96
         Left = 0
      End
      Begin Tables = 
         Begin Table = "s"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 121
               Right = 265
            End
            DisplayFlags = 280
            TopColumn = 37
         End
         Begin Table = "ss"
            Begin Extent = 
               Top = 6
               Left = 303
               Bottom = 121
               Right = 495
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "l"
            Begin Extent = 
               Top = 6
               Left = 533
               Bottom = 121
               Right = 735
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "a1"
            Begin Extent = 
               Top = 6
               Left = 773
               Bottom = 121
               Right = 975
            End
            DisplayFlags = 280
            TopColumn = 31
         End
         Begin Table = "p"
            Begin Extent = 
               Top = 126
               Left = 38
               Bottom = 241
               Right = 269
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "sr"
            Begin Extent = 
               Top = 126
               Left = 307
               Bottom = 226
               Right = 497
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "aa"
            Begin Extent = 
               Top = 126
               Left = 535
               Bottom = 241
               Right = 725
            End
            DisplayFlags = 280
            TopColumn = 0
         ', 'USER', N'dbo', 'VIEW', N'vw_Control', NULL, NULL
GO
EXEC sp_addextendedproperty N'MS_DiagramPane2', N'End
         Begin Table = "o"
            Begin Extent = 
               Top = 126
               Left = 763
               Bottom = 241
               Right = 953
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      RowHeights = 220
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
', 'USER', N'dbo', 'VIEW', N'vw_Control', NULL, NULL
GO
DECLARE @xp int
SELECT @xp=2
EXEC sp_addextendedproperty N'MS_DiagramPaneCount', @xp, 'USER', N'dbo', 'VIEW', N'vw_Control', NULL, NULL
GO
